<?php
//======================================================================================
//
// Function: REEFTintegrationLog - does the cust_number exists?
//
// Programmer: JKJ
// Date      : 2025-05-08
//
// Workers unite...
//
// Copyright Reeft A/S (c) - 2025
//======================================================================================

//======================================================================================
// Set start time
//======================================================================================

	$starttime = microtime(true);
	
//======================================================================================
// Get input
//======================================================================================

	if (isset($_REQUEST["cust_number"])) {
		$input_cust_number = $_REQUEST["cust_number"];
	} else {
		$input_cust_number = '';
	}

//======================================================================================
// General config
//======================================================================================
	include "config/config.php";

//======================================================================================
// Get input
//======================================================================================

//======================================================================================
// Get session variables
//======================================================================================
	include "include/getsession.php";
	include "include/sec2hms.php";
	include "include/REEFT_date_convert.php";

//======================================================================================
// Set language
//======================================================================================

	include "include/set_language.php";


//======================================================================================
// Set defaults
//======================================================================================

	$entries_found = 0;

	$currentDate = date('Y-m-d');
	$currentTime = date('H:i:s');

	$returnCode = '00';
	$returnMsg 	= 'Alles ist gut';

	// Init
	$aryDetail = array();

	header('Content-Type: application/json;charset=utf-8');

//======================================================================================
// Set database
//======================================================================================

	//$db_name = 'customer/REEFT_integration.sqlite3';
	$db_name = $CUSTOMER_DATABASE_PATH;
	$DFT_SQLLITE_IP	= $db_name;	

//======================================================================================
// Check if database file exists
//======================================================================================
	if (!file_exists($db_name)) {
		die(json_encode(['error' => "Database file '$db_name' does not exist."]));
	}

//======================================================================================
// Connect to some DB
//======================================================================================

	include "include/db_connect.php";

//======================================================================================
// Init some fields
//======================================================================================

		$pk_customer 	= 0;
		$cust_active 	= '';
		$cust_number 	= '';
		$cust_name 		= '';
		$cust_group 	= 0;

//======================================================================================
// Create SQL - active records
//======================================================================================
	$recordsTotalActive = 0;

	$sql =  "SELECT * FROM reeft_customer WHERE cust_number = '$input_cust_number'";
	
	//echo $sql;
	
	include "include/db_run_sql.php";

	foreach( $data as $row )
	{
		$pk_customer 	= $row["pk_customer"];
		$cust_active 	= $row["cust_active"];
		$cust_number 	= $row["cust_number"];
		$cust_name 		= $row["cust_name"];
		$cust_group 	= $row["cust_group"];
	}

//======================================================================================
// Customer exists
//======================================================================================

	if ( $pk_customer > 0 ) {
		$customer_exists 	= 'Y';
		$returnCode    		= '00';
		$returnMsg 	   		= 'Customer does exists';
		$entries_found 		= 1;
	} else {
		$customer_exists 	= 'N';
		$returnCode 		= '99';
		$returnMsg 			= 'Customer does not exists';
		$entries_found 		= 0;
	}

//======================================================================================
// Calculate response time
//======================================================================================
	$endtime 			= microtime(true);
	$response_time 		= $endtime - $starttime;
	$response_time 		= number_format($response_time, 6, '.', '');
	$response_time_raw 	= number_format($response_time, 6, '.', '');
	$response_time 		= '(' . $response_time . ' seconds)';
	$response_time_raw 	= $response_time_raw;

//======================================================================================
// Create header
//======================================================================================
	$aryHeader = array();
	
	$aryHeader["entries_found"] 				= $entries_found;
	$aryHeader["returnCode"] 					= $returnCode;
	$aryHeader["returnMsg"] 					= $returnMsg;
	
	$aryHeader["currentDate"] 					= $currentDate;
	$aryHeader["currentTime"] 					= $currentTime;

	$aryHeader["input_customer"] 				= $input_cust_number;
	$aryHeader["customer_exists"] 				= $customer_exists;
	$aryHeader["pk_customer"] 					= $pk_customer;
	$aryHeader["cust_active"] 					= $cust_active;
	$aryHeader["cust_number"] 					= $cust_number;
	$aryHeader["cust_name"] 					= $cust_name;
	$aryHeader["cust_group"] 					= $cust_group;
	
	$aryHeader["response_sec"] 					= $response_time;
	$aryHeader["response_sec_raw"] 				= $response_time_raw;

	// Create array and prepare for json encoding
	$returnJson["header"] 						= $aryHeader;

//======================================================================================
// Paint it black
//======================================================================================
    echo(json_encode($returnJson));

?>